---------------------------------------------------------
Microsoft OLE DB Provider for Oracle, version 2.0 Readme File
---------------------------------------------------------

(c) 1998 Microsoft Corporation. All rights reserved.

This document provides late-breaking or other information that supplements the Microsoft OLE DB Provider for Oracle documentation.

--------
CONTENTS
--------

1. PRODUCT DESCRIPTION

2. SYSTEM REQUIREMENTS

3. TECHNICAL NOTES

4. KNOWN LIMITATIONS

----------------------
1. PRODUCT DESCRIPTION
----------------------
This provider enables OLE DB consumers to access Oracle data sources.
It is new with Microsoft Data Access 2.0. (The provider's version number matches the Data Access version number.)

----------------------
2. SYSTEM REQUIREMENTS
----------------------
The Microsoft OLE DB Provider for Oracle provides access to Oracle 7.3 or Oracle 8 databases using the Oracle Client Software, version 7.3.3.4.0 or greater, which must be installed on the client machine. Note that this provider has been tested with Oracle Client Software version 7.3.3.4.0 and SQL*Net version 2.3.3.0.4, and these versions have produced the best results. When upgrading an Oracle client, it is important both to install the client upgrade and also to apply the "Required Supporting Files" that ships with the Server patch. 

For more information on Oracle products, refer to your Oracle documentation set.

------------------
3. TECHNICAL NOTES
------------------
a) The Microsoft OLE DB Provider for Oracle data sources does not directly support scrolling, nor does it support updating through the rowset using IRowsetChange. If the provider is instantiated using IDataInitialize, or invoked through ADO, Service Components will provide updating and scrolling functionality if requested by the application. In addition, the provider does support executing SQL update commands.

b) In several cases, numeric data will be returned as DBTYPE_VARNUMERIC, a new data type in OLE DB 2.0. The most notable situations are for columns defined as FLOAT, NUMBER (without precision or scale), computed numeric columns, or any situation where the scale is either negative or exceeds 38 digits.

c) IDBSchemaRowset::GetRowset performs case-sensitive selection only if you quote the value passed into IDBSchemaRowset.  

d) The Transaction Unit Of Work as reported by GetTransaction will always be NULL. For example, get a transaction from a session, and call GetTransaction on it. The XACTUOW from the XACTTRANSINFO will always be NULL.

--------------------
4. KNOWN LIMITATIONS
--------------------
a) This provider doesn't support the {resultset} escape implemented by the Microsoft ODBC Driver for Oracle.

b) OLE DB 2.0 includes a new flag in IConvertType::CanConvert, which is DBCONVERTFLAGS_FROMVARIANT. This flag is supported by the provider, however it has no effect on the return value from CanConvert at this time.  

